package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WebUserCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public WebUserCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPhonenumIsNull() {
            addCriterion("PHONENUM is null");
            return (Criteria) this;
        }

        public Criteria andPhonenumIsNotNull() {
            addCriterion("PHONENUM is not null");
            return (Criteria) this;
        }

        public Criteria andPhonenumEqualTo(String value) {
            addCriterion("PHONENUM =", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumNotEqualTo(String value) {
            addCriterion("PHONENUM <>", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumGreaterThan(String value) {
            addCriterion("PHONENUM >", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumGreaterThanOrEqualTo(String value) {
            addCriterion("PHONENUM >=", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumLessThan(String value) {
            addCriterion("PHONENUM <", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumLessThanOrEqualTo(String value) {
            addCriterion("PHONENUM <=", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumLike(String value) {
            addCriterion("PHONENUM like", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumNotLike(String value) {
            addCriterion("PHONENUM not like", value, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumIn(List<String> values) {
            addCriterion("PHONENUM in", values, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumNotIn(List<String> values) {
            addCriterion("PHONENUM not in", values, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumBetween(String value1, String value2) {
            addCriterion("PHONENUM between", value1, value2, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPhonenumNotBetween(String value1, String value2) {
            addCriterion("PHONENUM not between", value1, value2, "phonenum");
            return (Criteria) this;
        }

        public Criteria andPwdIsNull() {
            addCriterion("PWD is null");
            return (Criteria) this;
        }

        public Criteria andPwdIsNotNull() {
            addCriterion("PWD is not null");
            return (Criteria) this;
        }

        public Criteria andPwdEqualTo(String value) {
            addCriterion("PWD =", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotEqualTo(String value) {
            addCriterion("PWD <>", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThan(String value) {
            addCriterion("PWD >", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThanOrEqualTo(String value) {
            addCriterion("PWD >=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThan(String value) {
            addCriterion("PWD <", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThanOrEqualTo(String value) {
            addCriterion("PWD <=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLike(String value) {
            addCriterion("PWD like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotLike(String value) {
            addCriterion("PWD not like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdIn(List<String> values) {
            addCriterion("PWD in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotIn(List<String> values) {
            addCriterion("PWD not in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdBetween(String value1, String value2) {
            addCriterion("PWD between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotBetween(String value1, String value2) {
            addCriterion("PWD not between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNull() {
            addCriterion("REGTYPE is null");
            return (Criteria) this;
        }

        public Criteria andRegtypeIsNotNull() {
            addCriterion("REGTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRegtypeEqualTo(Integer value) {
            addCriterion("REGTYPE =", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotEqualTo(Integer value) {
            addCriterion("REGTYPE <>", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThan(Integer value) {
            addCriterion("REGTYPE >", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("REGTYPE >=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThan(Integer value) {
            addCriterion("REGTYPE <", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeLessThanOrEqualTo(Integer value) {
            addCriterion("REGTYPE <=", value, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeIn(List<Integer> values) {
            addCriterion("REGTYPE in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotIn(List<Integer> values) {
            addCriterion("REGTYPE not in", values, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeBetween(Integer value1, Integer value2) {
            addCriterion("REGTYPE between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andRegtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("REGTYPE not between", value1, value2, "regtype");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNull() {
            addCriterion("USERTYPE is null");
            return (Criteria) this;
        }

        public Criteria andUsertypeIsNotNull() {
            addCriterion("USERTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andUsertypeEqualTo(Integer value) {
            addCriterion("USERTYPE =", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotEqualTo(Integer value) {
            addCriterion("USERTYPE <>", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThan(Integer value) {
            addCriterion("USERTYPE >", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("USERTYPE >=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThan(Integer value) {
            addCriterion("USERTYPE <", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeLessThanOrEqualTo(Integer value) {
            addCriterion("USERTYPE <=", value, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeIn(List<Integer> values) {
            addCriterion("USERTYPE in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotIn(List<Integer> values) {
            addCriterion("USERTYPE not in", values, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeBetween(Integer value1, Integer value2) {
            addCriterion("USERTYPE between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andUsertypeNotBetween(Integer value1, Integer value2) {
            addCriterion("USERTYPE not between", value1, value2, "usertype");
            return (Criteria) this;
        }

        public Criteria andUseraddrIsNull() {
            addCriterion("USERADDR is null");
            return (Criteria) this;
        }

        public Criteria andUseraddrIsNotNull() {
            addCriterion("USERADDR is not null");
            return (Criteria) this;
        }

        public Criteria andUseraddrEqualTo(String value) {
            addCriterion("USERADDR =", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrNotEqualTo(String value) {
            addCriterion("USERADDR <>", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrGreaterThan(String value) {
            addCriterion("USERADDR >", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrGreaterThanOrEqualTo(String value) {
            addCriterion("USERADDR >=", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrLessThan(String value) {
            addCriterion("USERADDR <", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrLessThanOrEqualTo(String value) {
            addCriterion("USERADDR <=", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrLike(String value) {
            addCriterion("USERADDR like", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrNotLike(String value) {
            addCriterion("USERADDR not like", value, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrIn(List<String> values) {
            addCriterion("USERADDR in", values, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrNotIn(List<String> values) {
            addCriterion("USERADDR not in", values, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrBetween(String value1, String value2) {
            addCriterion("USERADDR between", value1, value2, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUseraddrNotBetween(String value1, String value2) {
            addCriterion("USERADDR not between", value1, value2, "useraddr");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNull() {
            addCriterion("USERNAME is null");
            return (Criteria) this;
        }

        public Criteria andUsernameIsNotNull() {
            addCriterion("USERNAME is not null");
            return (Criteria) this;
        }

        public Criteria andUsernameEqualTo(String value) {
            addCriterion("USERNAME =", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotEqualTo(String value) {
            addCriterion("USERNAME <>", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThan(String value) {
            addCriterion("USERNAME >", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameGreaterThanOrEqualTo(String value) {
            addCriterion("USERNAME >=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThan(String value) {
            addCriterion("USERNAME <", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLessThanOrEqualTo(String value) {
            addCriterion("USERNAME <=", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameLike(String value) {
            addCriterion("USERNAME like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotLike(String value) {
            addCriterion("USERNAME not like", value, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameIn(List<String> values) {
            addCriterion("USERNAME in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotIn(List<String> values) {
            addCriterion("USERNAME not in", values, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameBetween(String value1, String value2) {
            addCriterion("USERNAME between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andUsernameNotBetween(String value1, String value2) {
            addCriterion("USERNAME not between", value1, value2, "username");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andRegTimeIsNull() {
            addCriterion("REG_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRegTimeIsNotNull() {
            addCriterion("REG_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRegTimeEqualTo(Date value) {
            addCriterion("REG_TIME =", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotEqualTo(Date value) {
            addCriterion("REG_TIME <>", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeGreaterThan(Date value) {
            addCriterion("REG_TIME >", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("REG_TIME >=", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeLessThan(Date value) {
            addCriterion("REG_TIME <", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeLessThanOrEqualTo(Date value) {
            addCriterion("REG_TIME <=", value, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeIn(List<Date> values) {
            addCriterion("REG_TIME in", values, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotIn(List<Date> values) {
            addCriterion("REG_TIME not in", values, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeBetween(Date value1, Date value2) {
            addCriterion("REG_TIME between", value1, value2, "regTime");
            return (Criteria) this;
        }

        public Criteria andRegTimeNotBetween(Date value1, Date value2) {
            addCriterion("REG_TIME not between", value1, value2, "regTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeIsNull() {
            addCriterion("LAST_MODIFY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeIsNotNull() {
            addCriterion("LAST_MODIFY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeEqualTo(Date value) {
            addCriterion("LAST_MODIFY_TIME =", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeNotEqualTo(Date value) {
            addCriterion("LAST_MODIFY_TIME <>", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeGreaterThan(Date value) {
            addCriterion("LAST_MODIFY_TIME >", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_MODIFY_TIME >=", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeLessThan(Date value) {
            addCriterion("LAST_MODIFY_TIME <", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeLessThanOrEqualTo(Date value) {
            addCriterion("LAST_MODIFY_TIME <=", value, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeIn(List<Date> values) {
            addCriterion("LAST_MODIFY_TIME in", values, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeNotIn(List<Date> values) {
            addCriterion("LAST_MODIFY_TIME not in", values, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeBetween(Date value1, Date value2) {
            addCriterion("LAST_MODIFY_TIME between", value1, value2, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andLastModifyTimeNotBetween(Date value1, Date value2) {
            addCriterion("LAST_MODIFY_TIME not between", value1, value2, "lastModifyTime");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("BARCODE is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("BARCODE is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("BARCODE =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("BARCODE <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("BARCODE >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("BARCODE >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("BARCODE <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("BARCODE <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("BARCODE like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("BARCODE not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("BARCODE in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("BARCODE not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("BARCODE between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("BARCODE not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingIsNull() {
            addCriterion("ADDR_BUILDING is null");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingIsNotNull() {
            addCriterion("ADDR_BUILDING is not null");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingEqualTo(String value) {
            addCriterion("ADDR_BUILDING =", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingNotEqualTo(String value) {
            addCriterion("ADDR_BUILDING <>", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingGreaterThan(String value) {
            addCriterion("ADDR_BUILDING >", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_BUILDING >=", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingLessThan(String value) {
            addCriterion("ADDR_BUILDING <", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingLessThanOrEqualTo(String value) {
            addCriterion("ADDR_BUILDING <=", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingLike(String value) {
            addCriterion("ADDR_BUILDING like", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingNotLike(String value) {
            addCriterion("ADDR_BUILDING not like", value, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingIn(List<String> values) {
            addCriterion("ADDR_BUILDING in", values, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingNotIn(List<String> values) {
            addCriterion("ADDR_BUILDING not in", values, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingBetween(String value1, String value2) {
            addCriterion("ADDR_BUILDING between", value1, value2, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrBuildingNotBetween(String value1, String value2) {
            addCriterion("ADDR_BUILDING not between", value1, value2, "addrBuilding");
            return (Criteria) this;
        }

        public Criteria andAddrUnitIsNull() {
            addCriterion("ADDR_UNIT is null");
            return (Criteria) this;
        }

        public Criteria andAddrUnitIsNotNull() {
            addCriterion("ADDR_UNIT is not null");
            return (Criteria) this;
        }

        public Criteria andAddrUnitEqualTo(String value) {
            addCriterion("ADDR_UNIT =", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitNotEqualTo(String value) {
            addCriterion("ADDR_UNIT <>", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitGreaterThan(String value) {
            addCriterion("ADDR_UNIT >", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_UNIT >=", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitLessThan(String value) {
            addCriterion("ADDR_UNIT <", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitLessThanOrEqualTo(String value) {
            addCriterion("ADDR_UNIT <=", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitLike(String value) {
            addCriterion("ADDR_UNIT like", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitNotLike(String value) {
            addCriterion("ADDR_UNIT not like", value, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitIn(List<String> values) {
            addCriterion("ADDR_UNIT in", values, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitNotIn(List<String> values) {
            addCriterion("ADDR_UNIT not in", values, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitBetween(String value1, String value2) {
            addCriterion("ADDR_UNIT between", value1, value2, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrUnitNotBetween(String value1, String value2) {
            addCriterion("ADDR_UNIT not between", value1, value2, "addrUnit");
            return (Criteria) this;
        }

        public Criteria andAddrFloorIsNull() {
            addCriterion("ADDR_FLOOR is null");
            return (Criteria) this;
        }

        public Criteria andAddrFloorIsNotNull() {
            addCriterion("ADDR_FLOOR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrFloorEqualTo(String value) {
            addCriterion("ADDR_FLOOR =", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorNotEqualTo(String value) {
            addCriterion("ADDR_FLOOR <>", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorGreaterThan(String value) {
            addCriterion("ADDR_FLOOR >", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_FLOOR >=", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorLessThan(String value) {
            addCriterion("ADDR_FLOOR <", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorLessThanOrEqualTo(String value) {
            addCriterion("ADDR_FLOOR <=", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorLike(String value) {
            addCriterion("ADDR_FLOOR like", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorNotLike(String value) {
            addCriterion("ADDR_FLOOR not like", value, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorIn(List<String> values) {
            addCriterion("ADDR_FLOOR in", values, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorNotIn(List<String> values) {
            addCriterion("ADDR_FLOOR not in", values, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorBetween(String value1, String value2) {
            addCriterion("ADDR_FLOOR between", value1, value2, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrFloorNotBetween(String value1, String value2) {
            addCriterion("ADDR_FLOOR not between", value1, value2, "addrFloor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorIsNull() {
            addCriterion("ADDR_DOOR is null");
            return (Criteria) this;
        }

        public Criteria andAddrDoorIsNotNull() {
            addCriterion("ADDR_DOOR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrDoorEqualTo(String value) {
            addCriterion("ADDR_DOOR =", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorNotEqualTo(String value) {
            addCriterion("ADDR_DOOR <>", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorGreaterThan(String value) {
            addCriterion("ADDR_DOOR >", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_DOOR >=", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorLessThan(String value) {
            addCriterion("ADDR_DOOR <", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorLessThanOrEqualTo(String value) {
            addCriterion("ADDR_DOOR <=", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorLike(String value) {
            addCriterion("ADDR_DOOR like", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorNotLike(String value) {
            addCriterion("ADDR_DOOR not like", value, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorIn(List<String> values) {
            addCriterion("ADDR_DOOR in", values, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorNotIn(List<String> values) {
            addCriterion("ADDR_DOOR not in", values, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorBetween(String value1, String value2) {
            addCriterion("ADDR_DOOR between", value1, value2, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrDoorNotBetween(String value1, String value2) {
            addCriterion("ADDR_DOOR not between", value1, value2, "addrDoor");
            return (Criteria) this;
        }

        public Criteria andAddrOtherIsNull() {
            addCriterion("ADDR_OTHER is null");
            return (Criteria) this;
        }

        public Criteria andAddrOtherIsNotNull() {
            addCriterion("ADDR_OTHER is not null");
            return (Criteria) this;
        }

        public Criteria andAddrOtherEqualTo(String value) {
            addCriterion("ADDR_OTHER =", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherNotEqualTo(String value) {
            addCriterion("ADDR_OTHER <>", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherGreaterThan(String value) {
            addCriterion("ADDR_OTHER >", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_OTHER >=", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherLessThan(String value) {
            addCriterion("ADDR_OTHER <", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherLessThanOrEqualTo(String value) {
            addCriterion("ADDR_OTHER <=", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherLike(String value) {
            addCriterion("ADDR_OTHER like", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherNotLike(String value) {
            addCriterion("ADDR_OTHER not like", value, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherIn(List<String> values) {
            addCriterion("ADDR_OTHER in", values, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherNotIn(List<String> values) {
            addCriterion("ADDR_OTHER not in", values, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherBetween(String value1, String value2) {
            addCriterion("ADDR_OTHER between", value1, value2, "addrOther");
            return (Criteria) this;
        }

        public Criteria andAddrOtherNotBetween(String value1, String value2) {
            addCriterion("ADDR_OTHER not between", value1, value2, "addrOther");
            return (Criteria) this;
        }

        public Criteria andVisualCoinIsNull() {
            addCriterion("VISUAL_COIN is null");
            return (Criteria) this;
        }

        public Criteria andVisualCoinIsNotNull() {
            addCriterion("VISUAL_COIN is not null");
            return (Criteria) this;
        }

        public Criteria andVisualCoinEqualTo(Double value) {
            addCriterion("VISUAL_COIN =", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinNotEqualTo(Double value) {
            addCriterion("VISUAL_COIN <>", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinGreaterThan(Double value) {
            addCriterion("VISUAL_COIN >", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinGreaterThanOrEqualTo(Double value) {
            addCriterion("VISUAL_COIN >=", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinLessThan(Double value) {
            addCriterion("VISUAL_COIN <", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinLessThanOrEqualTo(Double value) {
            addCriterion("VISUAL_COIN <=", value, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinIn(List<Double> values) {
            addCriterion("VISUAL_COIN in", values, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinNotIn(List<Double> values) {
            addCriterion("VISUAL_COIN not in", values, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinBetween(Double value1, Double value2) {
            addCriterion("VISUAL_COIN between", value1, value2, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andVisualCoinNotBetween(Double value1, Double value2) {
            addCriterion("VISUAL_COIN not between", value1, value2, "visualCoin");
            return (Criteria) this;
        }

        public Criteria andCreditIsNull() {
            addCriterion("CREDIT is null");
            return (Criteria) this;
        }

        public Criteria andCreditIsNotNull() {
            addCriterion("CREDIT is not null");
            return (Criteria) this;
        }

        public Criteria andCreditEqualTo(Double value) {
            addCriterion("CREDIT =", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditNotEqualTo(Double value) {
            addCriterion("CREDIT <>", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditGreaterThan(Double value) {
            addCriterion("CREDIT >", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditGreaterThanOrEqualTo(Double value) {
            addCriterion("CREDIT >=", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditLessThan(Double value) {
            addCriterion("CREDIT <", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditLessThanOrEqualTo(Double value) {
            addCriterion("CREDIT <=", value, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditIn(List<Double> values) {
            addCriterion("CREDIT in", values, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditNotIn(List<Double> values) {
            addCriterion("CREDIT not in", values, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditBetween(Double value1, Double value2) {
            addCriterion("CREDIT between", value1, value2, "credit");
            return (Criteria) this;
        }

        public Criteria andCreditNotBetween(Double value1, Double value2) {
            addCriterion("CREDIT not between", value1, value2, "credit");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserIsNull() {
            addCriterion("TMCREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserIsNotNull() {
            addCriterion("TMCREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserEqualTo(String value) {
            addCriterion("TMCREATE_USER =", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserNotEqualTo(String value) {
            addCriterion("TMCREATE_USER <>", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserGreaterThan(String value) {
            addCriterion("TMCREATE_USER >", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("TMCREATE_USER >=", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserLessThan(String value) {
            addCriterion("TMCREATE_USER <", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserLessThanOrEqualTo(String value) {
            addCriterion("TMCREATE_USER <=", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserLike(String value) {
            addCriterion("TMCREATE_USER like", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserNotLike(String value) {
            addCriterion("TMCREATE_USER not like", value, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserIn(List<String> values) {
            addCriterion("TMCREATE_USER in", values, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserNotIn(List<String> values) {
            addCriterion("TMCREATE_USER not in", values, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserBetween(String value1, String value2) {
            addCriterion("TMCREATE_USER between", value1, value2, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andTmcreateUserNotBetween(String value1, String value2) {
            addCriterion("TMCREATE_USER not between", value1, value2, "tmcreateUser");
            return (Criteria) this;
        }

        public Criteria andUserStatusIsNull() {
            addCriterion("USER_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andUserStatusIsNotNull() {
            addCriterion("USER_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andUserStatusEqualTo(Integer value) {
            addCriterion("USER_STATUS =", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusNotEqualTo(Integer value) {
            addCriterion("USER_STATUS <>", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusGreaterThan(Integer value) {
            addCriterion("USER_STATUS >", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("USER_STATUS >=", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusLessThan(Integer value) {
            addCriterion("USER_STATUS <", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusLessThanOrEqualTo(Integer value) {
            addCriterion("USER_STATUS <=", value, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusIn(List<Integer> values) {
            addCriterion("USER_STATUS in", values, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusNotIn(List<Integer> values) {
            addCriterion("USER_STATUS not in", values, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusBetween(Integer value1, Integer value2) {
            addCriterion("USER_STATUS between", value1, value2, "userStatus");
            return (Criteria) this;
        }

        public Criteria andUserStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("USER_STATUS not between", value1, value2, "userStatus");
            return (Criteria) this;
        }

        public Criteria andIdnumIsNull() {
            addCriterion("IDNUM is null");
            return (Criteria) this;
        }

        public Criteria andIdnumIsNotNull() {
            addCriterion("IDNUM is not null");
            return (Criteria) this;
        }

        public Criteria andIdnumEqualTo(String value) {
            addCriterion("IDNUM =", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotEqualTo(String value) {
            addCriterion("IDNUM <>", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumGreaterThan(String value) {
            addCriterion("IDNUM >", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumGreaterThanOrEqualTo(String value) {
            addCriterion("IDNUM >=", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumLessThan(String value) {
            addCriterion("IDNUM <", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumLessThanOrEqualTo(String value) {
            addCriterion("IDNUM <=", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumLike(String value) {
            addCriterion("IDNUM like", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotLike(String value) {
            addCriterion("IDNUM not like", value, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumIn(List<String> values) {
            addCriterion("IDNUM in", values, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotIn(List<String> values) {
            addCriterion("IDNUM not in", values, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumBetween(String value1, String value2) {
            addCriterion("IDNUM between", value1, value2, "idnum");
            return (Criteria) this;
        }

        public Criteria andIdnumNotBetween(String value1, String value2) {
            addCriterion("IDNUM not between", value1, value2, "idnum");
            return (Criteria) this;
        }

        public Criteria andYikatongIsNull() {
            addCriterion("YIKATONG is null");
            return (Criteria) this;
        }

        public Criteria andYikatongIsNotNull() {
            addCriterion("YIKATONG is not null");
            return (Criteria) this;
        }

        public Criteria andYikatongEqualTo(String value) {
            addCriterion("YIKATONG =", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongNotEqualTo(String value) {
            addCriterion("YIKATONG <>", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongGreaterThan(String value) {
            addCriterion("YIKATONG >", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongGreaterThanOrEqualTo(String value) {
            addCriterion("YIKATONG >=", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongLessThan(String value) {
            addCriterion("YIKATONG <", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongLessThanOrEqualTo(String value) {
            addCriterion("YIKATONG <=", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongLike(String value) {
            addCriterion("YIKATONG like", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongNotLike(String value) {
            addCriterion("YIKATONG not like", value, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongIn(List<String> values) {
            addCriterion("YIKATONG in", values, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongNotIn(List<String> values) {
            addCriterion("YIKATONG not in", values, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongBetween(String value1, String value2) {
            addCriterion("YIKATONG between", value1, value2, "yikatong");
            return (Criteria) this;
        }

        public Criteria andYikatongNotBetween(String value1, String value2) {
            addCriterion("YIKATONG not between", value1, value2, "yikatong");
            return (Criteria) this;
        }

        public Criteria andBankcardIsNull() {
            addCriterion("BANKCARD is null");
            return (Criteria) this;
        }

        public Criteria andBankcardIsNotNull() {
            addCriterion("BANKCARD is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardEqualTo(String value) {
            addCriterion("BANKCARD =", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotEqualTo(String value) {
            addCriterion("BANKCARD <>", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardGreaterThan(String value) {
            addCriterion("BANKCARD >", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardGreaterThanOrEqualTo(String value) {
            addCriterion("BANKCARD >=", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLessThan(String value) {
            addCriterion("BANKCARD <", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLessThanOrEqualTo(String value) {
            addCriterion("BANKCARD <=", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLike(String value) {
            addCriterion("BANKCARD like", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotLike(String value) {
            addCriterion("BANKCARD not like", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardIn(List<String> values) {
            addCriterion("BANKCARD in", values, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotIn(List<String> values) {
            addCriterion("BANKCARD not in", values, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardBetween(String value1, String value2) {
            addCriterion("BANKCARD between", value1, value2, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotBetween(String value1, String value2) {
            addCriterion("BANKCARD not between", value1, value2, "bankcard");
            return (Criteria) this;
        }

        public Criteria andSellnumIsNull() {
            addCriterion("SELLNUM is null");
            return (Criteria) this;
        }

        public Criteria andSellnumIsNotNull() {
            addCriterion("SELLNUM is not null");
            return (Criteria) this;
        }

        public Criteria andSellnumEqualTo(Double value) {
            addCriterion("SELLNUM =", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumNotEqualTo(Double value) {
            addCriterion("SELLNUM <>", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumGreaterThan(Double value) {
            addCriterion("SELLNUM >", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumGreaterThanOrEqualTo(Double value) {
            addCriterion("SELLNUM >=", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumLessThan(Double value) {
            addCriterion("SELLNUM <", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumLessThanOrEqualTo(Double value) {
            addCriterion("SELLNUM <=", value, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumIn(List<Double> values) {
            addCriterion("SELLNUM in", values, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumNotIn(List<Double> values) {
            addCriterion("SELLNUM not in", values, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumBetween(Double value1, Double value2) {
            addCriterion("SELLNUM between", value1, value2, "sellnum");
            return (Criteria) this;
        }

        public Criteria andSellnumNotBetween(Double value1, Double value2) {
            addCriterion("SELLNUM not between", value1, value2, "sellnum");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("CUSTOMER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("CUSTOMER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(Integer value) {
            addCriterion("CUSTOMER_ID =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(Integer value) {
            addCriterion("CUSTOMER_ID <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(Integer value) {
            addCriterion("CUSTOMER_ID >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUSTOMER_ID >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(Integer value) {
            addCriterion("CUSTOMER_ID <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(Integer value) {
            addCriterion("CUSTOMER_ID <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<Integer> values) {
            addCriterion("CUSTOMER_ID in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<Integer> values) {
            addCriterion("CUSTOMER_ID not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(Integer value1, Integer value2) {
            addCriterion("CUSTOMER_ID between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CUSTOMER_ID not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andAddrIdIsNull() {
            addCriterion("ADDR_ID is null");
            return (Criteria) this;
        }

        public Criteria andAddrIdIsNotNull() {
            addCriterion("ADDR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAddrIdEqualTo(Integer value) {
            addCriterion("ADDR_ID =", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotEqualTo(Integer value) {
            addCriterion("ADDR_ID <>", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdGreaterThan(Integer value) {
            addCriterion("ADDR_ID >", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ADDR_ID >=", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdLessThan(Integer value) {
            addCriterion("ADDR_ID <", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdLessThanOrEqualTo(Integer value) {
            addCriterion("ADDR_ID <=", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdIn(List<Integer> values) {
            addCriterion("ADDR_ID in", values, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotIn(List<Integer> values) {
            addCriterion("ADDR_ID not in", values, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdBetween(Integer value1, Integer value2) {
            addCriterion("ADDR_ID between", value1, value2, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ADDR_ID not between", value1, value2, "addrId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNull() {
            addCriterion("BRANCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andBranchIdIsNotNull() {
            addCriterion("BRANCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andBranchIdEqualTo(Integer value) {
            addCriterion("BRANCH_ID =", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotEqualTo(Integer value) {
            addCriterion("BRANCH_ID <>", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThan(Integer value) {
            addCriterion("BRANCH_ID >", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID >=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThan(Integer value) {
            addCriterion("BRANCH_ID <", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdLessThanOrEqualTo(Integer value) {
            addCriterion("BRANCH_ID <=", value, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdIn(List<Integer> values) {
            addCriterion("BRANCH_ID in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotIn(List<Integer> values) {
            addCriterion("BRANCH_ID not in", values, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andBranchIdNotBetween(Integer value1, Integer value2) {
            addCriterion("BRANCH_ID not between", value1, value2, "branchId");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinIsNull() {
            addCriterion("TT_VISUAL_COIN is null");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinIsNotNull() {
            addCriterion("TT_VISUAL_COIN is not null");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinEqualTo(Double value) {
            addCriterion("TT_VISUAL_COIN =", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinNotEqualTo(Double value) {
            addCriterion("TT_VISUAL_COIN <>", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinGreaterThan(Double value) {
            addCriterion("TT_VISUAL_COIN >", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinGreaterThanOrEqualTo(Double value) {
            addCriterion("TT_VISUAL_COIN >=", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinLessThan(Double value) {
            addCriterion("TT_VISUAL_COIN <", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinLessThanOrEqualTo(Double value) {
            addCriterion("TT_VISUAL_COIN <=", value, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinIn(List<Double> values) {
            addCriterion("TT_VISUAL_COIN in", values, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinNotIn(List<Double> values) {
            addCriterion("TT_VISUAL_COIN not in", values, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinBetween(Double value1, Double value2) {
            addCriterion("TT_VISUAL_COIN between", value1, value2, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andTtVisualCoinNotBetween(Double value1, Double value2) {
            addCriterion("TT_VISUAL_COIN not between", value1, value2, "ttVisualCoin");
            return (Criteria) this;
        }

        public Criteria andAgeIsNull() {
            addCriterion("AGE is null");
            return (Criteria) this;
        }

        public Criteria andAgeIsNotNull() {
            addCriterion("AGE is not null");
            return (Criteria) this;
        }

        public Criteria andAgeEqualTo(Double value) {
            addCriterion("AGE =", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotEqualTo(Double value) {
            addCriterion("AGE <>", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeGreaterThan(Double value) {
            addCriterion("AGE >", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeGreaterThanOrEqualTo(Double value) {
            addCriterion("AGE >=", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeLessThan(Double value) {
            addCriterion("AGE <", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeLessThanOrEqualTo(Double value) {
            addCriterion("AGE <=", value, "age");
            return (Criteria) this;
        }

        public Criteria andAgeIn(List<Double> values) {
            addCriterion("AGE in", values, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotIn(List<Double> values) {
            addCriterion("AGE not in", values, "age");
            return (Criteria) this;
        }

        public Criteria andAgeBetween(Double value1, Double value2) {
            addCriterion("AGE between", value1, value2, "age");
            return (Criteria) this;
        }

        public Criteria andAgeNotBetween(Double value1, Double value2) {
            addCriterion("AGE not between", value1, value2, "age");
            return (Criteria) this;
        }

        public Criteria andJobIsNull() {
            addCriterion("JOB is null");
            return (Criteria) this;
        }

        public Criteria andJobIsNotNull() {
            addCriterion("JOB is not null");
            return (Criteria) this;
        }

        public Criteria andJobEqualTo(Double value) {
            addCriterion("JOB =", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotEqualTo(Double value) {
            addCriterion("JOB <>", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobGreaterThan(Double value) {
            addCriterion("JOB >", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobGreaterThanOrEqualTo(Double value) {
            addCriterion("JOB >=", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobLessThan(Double value) {
            addCriterion("JOB <", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobLessThanOrEqualTo(Double value) {
            addCriterion("JOB <=", value, "job");
            return (Criteria) this;
        }

        public Criteria andJobIn(List<Double> values) {
            addCriterion("JOB in", values, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotIn(List<Double> values) {
            addCriterion("JOB not in", values, "job");
            return (Criteria) this;
        }

        public Criteria andJobBetween(Double value1, Double value2) {
            addCriterion("JOB between", value1, value2, "job");
            return (Criteria) this;
        }

        public Criteria andJobNotBetween(Double value1, Double value2) {
            addCriterion("JOB not between", value1, value2, "job");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("SEX is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("SEX is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("SEX =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("SEX <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("SEX >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEX >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("SEX <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("SEX <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("SEX in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("SEX not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("SEX between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("SEX not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andJobTextIsNull() {
            addCriterion("JOB_TEXT is null");
            return (Criteria) this;
        }

        public Criteria andJobTextIsNotNull() {
            addCriterion("JOB_TEXT is not null");
            return (Criteria) this;
        }

        public Criteria andJobTextEqualTo(String value) {
            addCriterion("JOB_TEXT =", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextNotEqualTo(String value) {
            addCriterion("JOB_TEXT <>", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextGreaterThan(String value) {
            addCriterion("JOB_TEXT >", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextGreaterThanOrEqualTo(String value) {
            addCriterion("JOB_TEXT >=", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextLessThan(String value) {
            addCriterion("JOB_TEXT <", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextLessThanOrEqualTo(String value) {
            addCriterion("JOB_TEXT <=", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextLike(String value) {
            addCriterion("JOB_TEXT like", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextNotLike(String value) {
            addCriterion("JOB_TEXT not like", value, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextIn(List<String> values) {
            addCriterion("JOB_TEXT in", values, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextNotIn(List<String> values) {
            addCriterion("JOB_TEXT not in", values, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextBetween(String value1, String value2) {
            addCriterion("JOB_TEXT between", value1, value2, "jobText");
            return (Criteria) this;
        }

        public Criteria andJobTextNotBetween(String value1, String value2) {
            addCriterion("JOB_TEXT not between", value1, value2, "jobText");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrIsNull() {
            addCriterion("ADDR_ID_STR is null");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrIsNotNull() {
            addCriterion("ADDR_ID_STR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrEqualTo(String value) {
            addCriterion("ADDR_ID_STR =", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrNotEqualTo(String value) {
            addCriterion("ADDR_ID_STR <>", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrGreaterThan(String value) {
            addCriterion("ADDR_ID_STR >", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_ID_STR >=", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrLessThan(String value) {
            addCriterion("ADDR_ID_STR <", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrLessThanOrEqualTo(String value) {
            addCriterion("ADDR_ID_STR <=", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrLike(String value) {
            addCriterion("ADDR_ID_STR like", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrNotLike(String value) {
            addCriterion("ADDR_ID_STR not like", value, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrIn(List<String> values) {
            addCriterion("ADDR_ID_STR in", values, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrNotIn(List<String> values) {
            addCriterion("ADDR_ID_STR not in", values, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrBetween(String value1, String value2) {
            addCriterion("ADDR_ID_STR between", value1, value2, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andAddrIdStrNotBetween(String value1, String value2) {
            addCriterion("ADDR_ID_STR not between", value1, value2, "addrIdStr");
            return (Criteria) this;
        }

        public Criteria andImgPathIsNull() {
            addCriterion("IMG_PATH is null");
            return (Criteria) this;
        }

        public Criteria andImgPathIsNotNull() {
            addCriterion("IMG_PATH is not null");
            return (Criteria) this;
        }

        public Criteria andImgPathEqualTo(String value) {
            addCriterion("IMG_PATH =", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathNotEqualTo(String value) {
            addCriterion("IMG_PATH <>", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathGreaterThan(String value) {
            addCriterion("IMG_PATH >", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathGreaterThanOrEqualTo(String value) {
            addCriterion("IMG_PATH >=", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathLessThan(String value) {
            addCriterion("IMG_PATH <", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathLessThanOrEqualTo(String value) {
            addCriterion("IMG_PATH <=", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathLike(String value) {
            addCriterion("IMG_PATH like", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathNotLike(String value) {
            addCriterion("IMG_PATH not like", value, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathIn(List<String> values) {
            addCriterion("IMG_PATH in", values, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathNotIn(List<String> values) {
            addCriterion("IMG_PATH not in", values, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathBetween(String value1, String value2) {
            addCriterion("IMG_PATH between", value1, value2, "imgPath");
            return (Criteria) this;
        }

        public Criteria andImgPathNotBetween(String value1, String value2) {
            addCriterion("IMG_PATH not between", value1, value2, "imgPath");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrIsNull() {
            addCriterion("APP_USERADDR is null");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrIsNotNull() {
            addCriterion("APP_USERADDR is not null");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrEqualTo(String value) {
            addCriterion("APP_USERADDR =", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrNotEqualTo(String value) {
            addCriterion("APP_USERADDR <>", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrGreaterThan(String value) {
            addCriterion("APP_USERADDR >", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrGreaterThanOrEqualTo(String value) {
            addCriterion("APP_USERADDR >=", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrLessThan(String value) {
            addCriterion("APP_USERADDR <", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrLessThanOrEqualTo(String value) {
            addCriterion("APP_USERADDR <=", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrLike(String value) {
            addCriterion("APP_USERADDR like", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrNotLike(String value) {
            addCriterion("APP_USERADDR not like", value, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrIn(List<String> values) {
            addCriterion("APP_USERADDR in", values, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrNotIn(List<String> values) {
            addCriterion("APP_USERADDR not in", values, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrBetween(String value1, String value2) {
            addCriterion("APP_USERADDR between", value1, value2, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andAppUseraddrNotBetween(String value1, String value2) {
            addCriterion("APP_USERADDR not between", value1, value2, "appUseraddr");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNull() {
            addCriterion("CUSTOMER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIsNotNull() {
            addCriterion("CUSTOMER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerNameEqualTo(String value) {
            addCriterion("CUSTOMER_NAME =", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotEqualTo(String value) {
            addCriterion("CUSTOMER_NAME <>", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThan(String value) {
            addCriterion("CUSTOMER_NAME >", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameGreaterThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_NAME >=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThan(String value) {
            addCriterion("CUSTOMER_NAME <", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLessThanOrEqualTo(String value) {
            addCriterion("CUSTOMER_NAME <=", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameLike(String value) {
            addCriterion("CUSTOMER_NAME like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotLike(String value) {
            addCriterion("CUSTOMER_NAME not like", value, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameIn(List<String> values) {
            addCriterion("CUSTOMER_NAME in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotIn(List<String> values) {
            addCriterion("CUSTOMER_NAME not in", values, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameBetween(String value1, String value2) {
            addCriterion("CUSTOMER_NAME between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andCustomerNameNotBetween(String value1, String value2) {
            addCriterion("CUSTOMER_NAME not between", value1, value2, "customerName");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNull() {
            addCriterion("DEPARTMENT is null");
            return (Criteria) this;
        }

        public Criteria andDepartmentIsNotNull() {
            addCriterion("DEPARTMENT is not null");
            return (Criteria) this;
        }

        public Criteria andDepartmentEqualTo(String value) {
            addCriterion("DEPARTMENT =", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotEqualTo(String value) {
            addCriterion("DEPARTMENT <>", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThan(String value) {
            addCriterion("DEPARTMENT >", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentGreaterThanOrEqualTo(String value) {
            addCriterion("DEPARTMENT >=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThan(String value) {
            addCriterion("DEPARTMENT <", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLessThanOrEqualTo(String value) {
            addCriterion("DEPARTMENT <=", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentLike(String value) {
            addCriterion("DEPARTMENT like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotLike(String value) {
            addCriterion("DEPARTMENT not like", value, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentIn(List<String> values) {
            addCriterion("DEPARTMENT in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotIn(List<String> values) {
            addCriterion("DEPARTMENT not in", values, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentBetween(String value1, String value2) {
            addCriterion("DEPARTMENT between", value1, value2, "department");
            return (Criteria) this;
        }

        public Criteria andDepartmentNotBetween(String value1, String value2) {
            addCriterion("DEPARTMENT not between", value1, value2, "department");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table WEB_USER
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}